Application SQL Server DBA/Production Support Resume Golden,CO |
您所在的位置：网站首页 › dba sql server › Application SQL Server DBA/Production Support Resume Golden,CO |
|
SUMMARY: MS SQL Server Database Administrator with Five+ years of experience managing SQL Server in PRODUCTION, DEVELOPMENT, QA and UAT environments Expertise in Managing PRODUCTION Databases on MS SQL Server 2012/2008 R 2/2008/2005/2000 in VIRTUAL and PHYSICAL environments. Experience in supporting and involvement in Disaster Recovery (DR) and High Availability Solutions (HA) using Database Mirroring and Log Shipping. Provided 24/7 and On - call Support for PRODUCTION environment Expertise in Database Administration activities like Installation, Configuration, Backup & Recovery, Database Security, Data Transformation Services, Database Designing and Query Optimization. Experience in VMWARE and managing multiple SQL Server Instances on Physical and VMWARE Hands on experience in implementing SNAPSHOT,TRANSACTIONAL and MERGE replication Hands on experience in implementing FULL, TRANSACTION and DIFFERENTIAL Backups Used third party tools like Redgate, SQL Litespeed and Commvault for Backups Used SPOTLIGHT and FOGLIGHT for Monitoring and Performance tuning Upgraded and Migrated SQL Server Systems from SQL 2000/2005 to SQL Server 2008 R2 Experience in performance tuning SQL Server using PROFLER, QUERY EXECUTION PLAN and INDEX TUNING WIZARD Extensive use of SQL Server DMV's for Performance Tuning. Experience in SSIS. Created basic and troubleshoot heavy duty SSIS packages and deployed the packages from development to different environments Expertise in MS SQL Installation, Migration, Upgrade, Configuration & Maintenance of multiple SQL server environments. Performed and involvement Capacity Planning and Logical/Physical database design. Strong experience in performing database consistency checks and planning and scheduling Recovery Procedures. Experience in developing and managing Stored Procedures, Triggers, Indexes, Views, Data Transformation Services and Locking. Monitoring and tuning SQL Server performance with multiple tools including Performance Monitor, SQL Profiler, Event Viewer, Index Tuning Wizard and Spotlight to achieve better performance, accessibility and efficiency. Experience in resolving Database Performance, Capacity and Distributed data issues. Proficient with SQL Enterprise Manager, SQL Query Analyzer and scheduling jobs with SQL Server Agent and SQL Profiler. Experience working with Very Large Databases (VLDBs) and Good knowledge of RDBMS . Understand C,C++,C#,VB, JAVA languages and Networking concepts.TECHNICAL SKILLS: Databases: MS SQL server 2012/2008 R 2/2008/2005/2000 Operating Systems: Windows NT/98/2000/XP/Vista/2003, 2007, VMWare ETL Tools: SQL Server Integration Services (SSIS), SQL Server DTS Other Tools: Redgate, Foglight, commvault, Litespeed, Legato Tap Backup. SQL Server Tools: SQL server Management Studio, SQL server Query Analyzer, SQL server mail service, DBCC, DTS, BCP, SQL server profiler, Event Viewer, and Index Tuning Wizard, SQL Server Agent, Log Shipping, T-SQL, DDL, SQLCMD, BIDS, Triggers. PROFESSIONAL EXPERIENCE: Confidential, Golden,CO Application SQL Server DBA/Production Support Responsibilities: Worked on Migration Project to migrate SQL Server from Lower Version to Higher Version Migrated SQL Server from SQL Server 2000/2005 to 2008 R2/2012 Worked primarily as a rotating PRODUCTION support DBA giving 24/7 Support on SQL 2012/2008 R2 Worked extensively on Virtual and VMware Environments. Worked on managing SQL Server Environment in High Availability(HA) and Disaster Recovery(DR) Involved in Performance Tuning on Production, QA and Staging servers of the current project. Worked on setting up and managing Snapshot and Transactional Replication Involved in Monitoring Performance of different production servers. Implemented Database Replicatioin and Log Shipping for disaster recovery. Maintained various databases for Production and Testing using SQL Server 2014/2012/2008 R2. Planning the location of data, index and Transaction log files on the disk. Performance tuning and optimization of procedures and queries. extensive use of SQL Server DMV's for Performance Tuning Worked extensively with SQL server Profiler, Execution plan and Index Tuning Wizard for performance bottlenecks Created the backup and restore strategy for production and development environment. Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics, Re-indexing and online Indexes. Using SQL Server Integration Services (SSIS) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for ETL application. Created extensive SQL Server Integration Services (SSIS) packages for ETL. Migrated MS SQL Server 2000/2005 to MS SQL Server 2008 R2 Managing schema objects such as tables, views, clusters, indexes, procedures, triggers & maintaining Referential Integrity depending on user requirements and converting them into technical specifications. Database and Transaction log backups & restoration, backup strategies, scheduling the backups. Backing up system & user databases and restoring them. Performing fine Tuning of Database Application. Cleansing and solving Database troubles. Heavy migration using SSIS, DTS and Data Integrator. Created Linked Servers for data retrieval using OLE DB data sources and providers.Environment: SQL Server 2014/2012/2008 R2/2005/2000, VMware, Rational, BandDAuto, Virtualization, SSIS, DTS, SQL Profiler, Clustering, Mirroring, Log Shipping, Windows 2008 R2/2003/2000, LiteSpeed Backup, IDera Diagnostic Manager. Confidential, Bloomsburg PASQL Server DBA/Production Support Responsibilities: Managing Production SQL Servers on VIRTUAL and PHYSICAL environments Installing and Configuring SQL Server 2005/2008/2008 R2. Supporting the business 24/7, maintaining 99.999 uptimes depending on the application and business SLA requirements. Involved in upgrading SQL Server 2000 instances to SQL Server 2008 R2 Involved in database design, database standards, T-SQL code reviews. Implemented Mirroring and Log Shipping for Disaster recovery Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS Scheduled package execution in SSIS Installing packages on multiple servers in SSIS Extensively worked on SSIS for data manipulation and data extraction, ETL Load Configured transactional and snapshot replication and managed publications, articles. Proactively involved in SQL Server Performance tuning at Database level, T-SQL level and operating system level. Maintained database response times and proactively generated performance reports. Automated most of the DBA Tasks and monitoring stats. Responsible for SQL Server Edition upgrades and SQL Server patch management. Created a mirrored database for reporting using Database Mirroring with high performance mode. Created database snapshots and stored procedures to load data from the snapshot database to the report database. Created Schemas, Logins, Tables, Clustered and Non-Clustered Indexes, Views, Functions and Stored Procedures. Trouble shooting and supporting all user problems by using SQL server profiler, network traces, Windows logs etc. Migrated DTS Packages to SSIS Package. Monitored event and server error logs for troubleshooting. Provided technical support during the development, design enhancement and implementation of production databases. Worked with the transaction processing area to develop both the physical and the logical database administration functions. Work with others in IT to build the logical database area and provide technical guidance during all phases of the development process.Environment: MS SQL server 2000/2005/2008 R2/2012, Windows 2003/2008 R2, Enterprise Manager, Query Analyzer, SQL Server Profiler, SSIS,Rational,BandDAuto. ConfidentialJr. MS SQL Server 2008/2005 DBA Responsibilities: As a Production and development support DBA responsible for maintaining 253 SQL Servers out of which 120 servers are production servers in which 70 were mission critical and 50 were business critical servers, remaining test and development servers. Installed SQL Server 2008 and SQL Server 2005 on windows 2003 and 2008 servers, applied service packs and security fix for all servers. Configured and maintained Log shipping architecture to provide backup server solution for 4 environments. Implemented transactional replication for data refresh. Managed all Publisher, Distributor and Subscriber database environments for the replication Experience in upgrading from SQL Server 2000 to SQL Server 2005 servers. Upgraded server from MS SQL Server 2005 to MS SQL Server 2008 Implemented SQL Server Mirroring on SQL 2008/2005 environments Created and involved in DTS, SSIS packages to import the data from MS Access and Oracle server to SQL Servers. Created SSIS packages in 2008 platform to Extract and Load data from diverse source (flat file, excel, xml and oracle) Used Send Mail, Bulk Insert, Execute SQL, Data Flow, Import Export control extensively in SSIS Performed Multi File Imports, Package configuration, Debugging Tasks and Scripts in SSIS Scheduled package execution in SSIS Involved in tuning SQL Server databases using available tuning methods like index tuning wizards, profiler and execution plans. Involved in setting up transactional replication in production environment. Created the standard documents for Disaster recovery testing and implemented them. Experienced with database sizing and capacity planning for production servers. Experienced with improving SQL Server using windows performance monitor to improve the server performance. Involved in securing the SQL Server environment and involved in setting up the user permissions. Experienced with creating database maintenance plans for efficient operations. Created the backup schedule for production, test and development servers. Worked with developers to do the database schema changes and database restore requests. Involved in restore operations to refresh the data from production to test servers. Experienced in troubleshooting production servers and fixed the user and application issues.Environment: MS SQL Server 2008 /2005, Windows 2000/2003/2008 Server operating systems. |
| CopyRight 2018-2019 办公设备维修网 版权所有 豫ICP备15022753号-3 |